خلاصہ

Expert in Microsoft Excel, Data, Numbers, Analysis and CRM management. Experience in making Customize solutions in Microsoft Excel and Access with minimum supervision. Excellent in maintaining office tasks such as Inventory Management and Planning, Distribution, Procurement, Marketing Services, Administrative support and HR. Knowledge of working with all company departments. Honest, Hardworking, Teamwork, Problem solving, Time Management, Critical Thinking, Decision making, Organizational, Stress Management, Adaptability and Extra Ordinary Learning Capabilities.

تجربہ

کمپنی کا لوگو
Assistant Manager Distribution
Global Pharmaceuticals Pvt Ltd
جنوری ۲۰۲۱ - جولائی ۲۰۲۳ | Islamabad, Pakistan

Planning fortnightly replenishments by analyzing sale history, Generating and Emailing 350+ SKU and 150+ Business Partner\'s inventory replenishment orders.Taking Orders and payments from Distributors, entering Sale Orders in SAP B1, coordination with logistics and warehouse for delivery, order tracking and dispatch status.Communication with Customers on new orders, back orders, delivery status, payments, pending claims, debit notes, credit notes and ledger corrections.Coordination with the Supply Chain on Short Stocks and provide them with inventory forecasts.Making Sale Revenue Forecast for Finance.Coordination with Accounts on Sale Order Approval, received payments, new distributor code openings, Ledger Corrections, and credit-debit notes.Verifying distributor documents and new distributor Code Opening in SAP B1. Keeping Record of distributor details in Microsoft Excel spreadsheet.Making detailed reports on sales, Available Stocks, product performance, distributor performance, inventory replenishment, Sales Revenue Forecast, Pending Sale Orders, Short expiry Stocks, Excess Inventory, Dead Inventory and Slow moving products.Supervising subordinates in sending distributor ledgers, checking claims and reports.Assisting Senior Distribution Manager on given tasks and Chief Executive Reports.

کمپنی کا لوگو
Sales Coordinator
Global Pharmaceuticals Pvt Ltd
جنوری ۲۰۱۹ - دسمبر ۲۰۲۰ | Islamabad, Pakistan

Closing daily, monthly, quarterly and yearly sales by collecting daily sales from branches on email and compiling in VBA automated spreadsheets.Making reports with visualizations on Sales, Discounts, sales trends, MTD, YTD, Business Group wise, Territory wise, Manager wise, Sales Officer wise and Branch wise achievements.Compiled yearly, quarterly and monthly sales force targets in Microsoft Excel and uploaded sales and targets in MREP CRM software.Communicating with sales force and branches on unassigned territories and updating territory mapping in the companys MREP, CRM & ERP software and Microsoft Excel Reports.Compiling monthly and quarterly 500+ sales force incentive calculation sheets. Processing incentive sheets to payroll-audit and resolve any problems.Maintaining sales force monthly, quarterly and yearly target vs. achievement sheets for sales force appraisals working.Reporting sales to the Marketing department, Non-Promotion department, Finance department and Chief Executive.

کمپنی کا لوگو
Inventory Coordinator
Global Pharmaceuticals Pvt Ltd
فروری ۲۰۱۴ - دسمبر ۲۰۱۸ | Islamabad, Pakistan

Maintaining Physician Sample, marketing literature and gift items warehouse Inventory in SAP B1.Generating Purchase Requests, Purchase Orders, Goods Receipts, Goods Issues and Inventory Transfers in SAP  B1.Checking monthly dispatch plans according to approved Budget.Dispatching promotional material to 500+ sales force by collecting dispatch approvals, goods issuance in SAP B1 and instructing warehouse inventory In-charge.Tracking items delivery and resolving all issues.Handling all promotional material purchases by Coordinating with Product Managers, Graphic Designers, Procurement Managers and Suppliers.Requesting for quotations from suppliers by email, doing price analysis, negotiating for best possible prices, lead time and specifications. Taking price approvals from Director Marketing and Sales.Processing supplier payments by submitting Goods Receipts along with purchase order and its invoice to accounts. Resolving invoice issues. Payments follow up from accounts. Dispatching payments to suppliers and keeping record.Processing new suppliers and products code openings. Closing completed Purchase Orders.Making reports for higher management on Expiry, Inventory Level, Purchase and Pending orders and payments.Taking approval for Hotel night stay, monthly and new launch meetings and Air Tickets from Director Marketing and Sales. Checking hotels and air ticketing invoices according to approvals. Correcting Hotel and Air Ticketing Invoices by contacting Hotels on email as well as phone calls. Submitting Hotel and Air Tickets invoices to accounts for payment.Attended many meetings with hotel marketing managers on behalf of my manager. Filling and processing hotel credit forms. Submitting monthly hotels and air tickets budget accruals to accounts department.Taking payment follow ups from accounts and dispatching payments.Filing all documents and Keeping record of received vs. paid for Purchases, Hotel and Air Ticketing Invoices.

کمپنی کا لوگو
Marketing Coordinator
Global Pharmaceuticals Pvt Ltd
فروری ۲۰۱۳ - جنوری ۲۰۱۴ | Islamabad, Pakistan

Maintaining 100+ Field Force HR Records and Hierarchy Charts.Communications for New Joining, Final Settlement and Resigns.Shortlisting and Arranging selected candidate interview appointments.Making and completing Joining and settlement files and process.New recruitment and resigned employee\'s record updating in software.Working on yearly increment sheets and Appraisal Working.Checking sales force tour plans and expenses. Submitting expenses to payroll.Contacting sales force on given tasks such as Sample and gift items approvals, detailing bags issuance, tour plans, expenses, promotional budget, marketing activities, new launch and monthly meetings.Compiling and recording the Promotional Budget given to Field Force.Filling all incoming and outgoing documents.

تعلیم

Allama Iqbal Open University (AIOU)
بیچلرز, بیچلرز ان کامرس, Bachelor In Commerce‎
Commerce, Accounting, Cost Accounting
فی صد 59%
2016

پیشہ ورانہ مہارتیں

ماہر Coordination
ماہر Data Analysis
ابتدائی DAX
متوسط Distribution
ماہر Export Consignments
متوسط HR
ماہر Inventory Management
متوسط Microsoft Access
ماہر Microsoft Excel
ماہر Order Management
ماہر Power Query
ابتدائی PowerBI
ماہر PowerPivot
ماہر Purchase/Procurement
متوسط Qlikview
متوسط Sale Closing & Reporting
ماہر VBA & Macros
ماہر Warehouse supervision

زبانیں

ماہر اردو
متوسط انگریزی

آپ کن کمپنیز کی پیروی کر رہے ہیں